[dbo].[BAEImisOrderLineGetAll]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEImisOrderLineGetAll
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@ORDER_NUMBER
float
8
SQL Script
create
procedure
[dbo]
.
[BAEImisOrderLineGetAll]
@ORDER_NUMBER
as
float
AS
SELECT
*
FROM
Order_Lines
WHERE
ORDER_NUMBER
=
@ORDER_NUMBER
ORDER
BY
LINE_NUMBER
;
GO
Uses
[dbo].[Order_Lines]
dbo